How to: Create a new table by typing data in Datasheet view (without Wizards).
Solution:
Click the 'Tables' tab in the Database window, click 'New', and select 'Datasheet View'.
NOTE: Never include a calculated field in the table.
1) If the Database window is not active, activate the Database window.
2) Click the 'Tables' tab in the Database window.
Tables tab
3) Click 'New'. (The New Table dialog box appears.)
4) Select 'Datasheet View' from the list box.
5) Click 'OK'. (The Table Datasheet view appears in a spreadsheet-like format with 'Field1' as the heading of the first column, 'Field2' the heading of the second column, etc.)
6) Type data in the table, using as many fields as needed. (The data types and properties are automatically set by Access.)
7) (Optional) Change the field names (i.e., column headings):
a) Select the desired field by clicking on the 'Field Selector'.
Field Selector
b) Select the 'Format' menu and select 'Rename Column'. (The current field name is highlighted at the top of the column.)
c) Type the desired name for the field.
d) Press ENTER.
e) Repeat step 7)a) through 7)d) for each field name to change.
8) Select the 'File' menu and select 'Save Layout'. (The Save As dialog box appears.)
9) Type a table name in the 'Table Name' box.
10) Click 'OK'.
11) Select the 'File' menu and select 'Close to close the table.
NOTE: If a dialog box appears stating that 'There is no primary key defined' and asking if a primary key should be created, click 'Yes' to allow Access to select the primary key.
